SnowflakeQueryV3_CL

Browse: 🏠 · Solutions · Connectors · Methods · Tables · Content · Parsers · ASIM Parsers · ASIM Products · Logic Apps · 📊

↑ Back to Tables Index


Attribute Value
Supports Transformations ✗ No
Ingestion API Supported ✓ Yes
Lake-Only Ingestion ✗ No (source)

Contents

Schema (87 columns)

Source: Connector definition

Column Name Type Description
AgentType string
AuthnEventId string
BindValues string
BytesDeleted string
BytesReadFromResult string
BytesScanned string
BytesSentOverTheNetwork string
BytesSpilledToLocalStorage string
BytesSpilledToRemoteStorage string
BytesWritten string
BytesWrittenToResult string
ChildQueriesWaitTime string
ClusterNumber string
CompilationTime string
CreditsUsedCloudServices string
DatabaseId string
DatabaseName string
EndTime string
ErrorCode string
ErrorMessage string
ExecutionStatus string
ExecutionTime string
ExternalFunctionTotalInvocations string
ExternalFunctionTotalReceivedBytes string
ExternalFunctionTotalReceivedRows string
ExternalFunctionTotalSentBytes string
ExternalFunctionTotalSentRows string
FaultHandlingTime string
Generation string
InboundDataTransferBytes string
InboundDataTransferCloud string
InboundDataTransferRegion string
IsClientGeneratedStatement string
ListExternalFilesTime string
OutboundDataTransferBytes string
OutboundDataTransferCloud string
OutboundDataTransferRegion string
PartitionsScanned string
PartitionsTotal string
PercentageScannedFromCache string
QueryAccelerationBytesScanned string
QueryAccelerationPartitionsScanned string
QueryAccelerationUpperLimitScaleFactor string
QueryHash string
QueryHashVersion string
QueryId string
QueryLoadPercent string
QueryParameterizedHash string
QueryParameterizedHashVersion string
QueryRetryCause string
QueryRetryTime string
QueryTag string
QueryText string
QueryType string
QueuedOverloadTime string
QueuedProvisioningTime string
QueuedRepairTime string
ReleaseVersion string
ResourceConstraint string
RoleName string
RoleType string
RowsDeleted string
RowsInserted string
RowsProduced string
RowsUnloaded string
RowsUpdated string
RowsWrittenToResult string
SchemaId string
SchemaName string
SecondaryRoleStats string
SessionId string
SnowflakeAccountIdentifier string Snowflake account identifier configured for this connection; hard-coded on every record so it can be differentiated.
StartTime string
TimeGenerated datetime
TotalElapsedTime string
TransactionBlockedTime string
TransactionId string
UserDatabaseId string
UserDatabaseName string
UserName string
UserSchemaId string
UserSchemaName string
UserType string
WarehouseId string
WarehouseName string
WarehouseSize string
WarehouseType string

Schema References

Official Microsoft Learn documentation for field/column information:

Solutions (1)

This table is used by the following solutions:

Connectors (1)

This table is ingested by the following connectors:

Connector Selection Criteria
Snowflake (via Codeless Connector Framework)

Content Items Using This Table (21)

Analytic Rules (10)

In solution Snowflake:

Analytic Rule Selection Criteria
Snowflake - Abnormal query process time
Snowflake - Multiple failed queries
Snowflake - Multiple login failures by user
Snowflake - Multiple login failures from single IP
Snowflake - Possible data destraction
Snowflake - Possible discovery activity
Snowflake - Possible privileges discovery activity
Snowflake - Query on sensitive or restricted table
Snowflake - Unusual query
Snowflake - User granted admin privileges

Hunting Queries (10)

In solution Snowflake:

Hunting Query Selection Criteria
Snowflake - Credit consuming queries
Snowflake - Deleted databases
Snowflake - Deleted tables
Snowflake - Failed logins
Snowflake - Privileged users' source IP addresses
Snowflake - Rarely used account
Snowflake - Rarely used privileged users
Snowflake - Time consuming queries
Snowflake - Unknown query type
Snowflake - Users' source IP addresses

Workbooks (1)

In solution Snowflake:

Workbook Selection Criteria
Snowflake

Parsers Using This Table (1)

Other Parsers (1)

Parser Solution Selection Criteria
Snowflake Snowflake

Browse: 🏠 · Solutions · Connectors · Methods · Tables · Content · Parsers · ASIM Parsers · ASIM Products · Logic Apps · 📊

↑ Back to Tables Index